PreparedItem

Entity Definition

Logical Name : PreparedItem
Physical Name : AS_ITM_PPR

A sub-type of Item that is manufactured (or prepared) for sale from a set of BulkItem via a Recipe. The distinction from StockItem being that PreparedItem is not booked into inventory when the item is manufactured; nor is it removed from inventory when it is sold; rather the inventory for the BulkItem constituent parts as defined by the recipe is reduced when the PreparedItem is sold.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
ItemID (FK)(PK)	A unique system assigned identifier for the retailer's SKU.	ID_ITM	IdentityUUID	char(32)
FoodItemHoldingTime	The number of minutes that a prepared food item may be held ready for sale. At the end of this time, the item must not be sold to a customer.	TM_HLDR_FD_ITM	QuantityShortCountMinutes	decimal(4,0)

Relationships

Parent Entity	Verb Phrase	Child Entity
PreparedItem	is assembled via	Recipe
Item	can be a	PreparedItem

Logical Views containing PreparedItem

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 01020 - Item Description - Enterprise View
Logical 01030 - Item Description - Recipe View